SSRS Report

• Name - Enter a name for the content item. This text appears during design mode (configuration).
• Title - Enter the text to display above this iPart on the rendered page. If blank, no title displays.
• Do not render in design mode - Select this option to prevent content record data from being loaded in the content editor. This improves performance during design time (configuration).
• Display a border around this content - Select this option to display a border around this iPart on the rendered page.
• Display the PDF Export button - Disabled by default.
• Display the Excel Export button - Disabled by default.
• Document system path to the SSRS Report runtime - Required. Enter a link to an existing Reporting Services Report (process engine):
  1. Click the select link next to the textbox
  2. Browse to $/Samples/ReportingServices or another report folder.
  3. Select a report (icon has an arrow on top of the report image).
• Hide the parameters section - Prevents users from seeing or changing the parameters for the report.
• Hide the toolbar - Hides the report viewer toolbar entirely.
• Hide the page navigation controls on the toolbar - Shows the report viewer toolbar without the page navigation controls.
• Hide all toolbar controls except the Print button - (Internet Explorer specific feature) Shows the toolbar with only the Print button. On all other browsers, hides the report viewer toolbar entirely.
• Inspect Session for parameters - Select this option to tell the iPart to look in Session for query parameter values.
• Inspect query string for parameters - Select this option to tell the iPart to look in the query string for query parameter values.
  • Tip: See this iMIS Community post for examples on how to use these parameter inspection options.

Notes

• This iPart uses version 10.0 ReportViewer, which supports IE8 natively and adds a Print button (IE8 and higher) to the toolbar.
• You can change the SSRS report formatting defaults by editing the SSRS parameters in the iMIS SystemConfig table.
• The process engine specified by the iPart loads a report template (.RDL file) from the document system and then creates a report data source (a DataTable) based on the SQL source for the IQA query. The report viewer combines the template and query to generate output.